github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q20.sql (about)

     1  select
     2      -- Required Columns
     3      certificate_arn as resource,
     4      case
     5          when not_after <= (current_date - interval '30' day) then 'ok'
     6          else 'alarm'
     7          end as status,
     8      title || ' expires ' || to_char(not_after, 'DD-Mon-YYYY') ||
     9      ' (' || extract(day from not_after - current_timestamp) || ' days).'
    10                      as reason,
    11      -- Additional Dimensions
    12      region,
    13      account_id
    14  from
    15      aws_acm_certificate;